46. 解决方案:OR

OR 问题的解决方案

  1. SELECT id
    FROM orders
    WHERE gloss_qty > 4000 OR poster_qty > 4000;
  2. 2.
SELECT *
FROM orders
WHERE standard_qty = 0 AND (gloss_qty > 1000 OR poster_qty > 1000);
  1. SELECT *
    FROM accounts
    WHERE (name LIKE 'C%' OR name LIKE 'W%') 
                  AND ((primary_poc LIKE '%ana%' OR primary_poc LIKE '%Ana%') 
                  AND primary_poc NOT LIKE '%eana%');